﻿CREATE PROCEDURE [dbo].[sp_CreateTemplate] 
    @templateName varchar(256), 
	@templateBody xml 
AS 
BEGIN
INSERT INTO PackageTemplates(TemplateName,TemplateBody) VALUES(@templateName,@templateBody);
SELECT SCOPE_IDENTITY();
END


